﻿-- =============================================
-- System Name:    Pre-Contract
-- Component:      Menu Adjustment
-- Created By:     Leo Ren (leoren@wicresoft.com)
-- Created Date:   2011-5-30
-- =============================================
update MenuConfig set IsEnabled = 0 where MenuID < 100

/****** Object:  Table [dbo].[MenuConfig]    Script Date: 06/22/2011 10:49:14 ******/
SET IDENTITY_INSERT [dbo].[MenuConfig] ON
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (100, N'Sales Feedback', N'销售反馈', NULL, 0, 100, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (101, N'The contracts which have no feedbacks', N'未反馈合同', N'Task/FeedbackPreContract.aspx?isFeedback=false', 100, 101, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (102, N'The contracts which have feedbacks', N'已反馈合同', N'Task/FeedbackPreContract.aspx?isFeedback=true', 100, 102, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (200, N'Reports', N'报表', NULL, 0, 200, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (201, N'Weekly Reports', N'周报', N'Report/Weekly/WeeklyReportIndex.aspx', 200, 201, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (202, N'Monthly Reports', N'月报', N'Report/Monthly/MonthlyReportIndex.aspx', 200, 202, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (300, N'Statistics', N'统计信息', NULL, 0, 300, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (301, N'All Pre-Contracts', N'所有预合同清单', N'Task/AllPre-Contracts.aspx', 300, 301, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (302, N'Tranferred PreContract', N'已转正预合同清单', N'Task/TransferredPreContract.aspx', 300, 302, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (303, N'Black List', N'黑名单统计', N'Report/BlackList.aspx', 300, 303, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (304, N'Key Project', N'关键项目统计', N'Task/KeyProjectSearch.aspx', 300, 304, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (400, N'Search', N'搜索', NULL, 0, 400, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (401, N'Quick Search', N'快速搜索', N'Task/QuerySearchPreContract.aspx', 400, 401, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (402, N'Advanced Search', N'高级搜索', N'Task/SearchPreContract.aspx', 400, 402, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (500, N'Data Management', N'数据维护', NULL, 0, 500, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (501, N'Import Pre-Contract', N'导入预合同信息', N'Task/ImportPreContract.aspx', 500, 501, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (502, N'Import Delivery Percentage', N'导入发货信息', N'Task/ImportDeliveryPercentage.aspx', 500, 502, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (503, N'Import Orion Forecast', N'导入Orion信息', N'Task/ImportOrionForecast.aspx', 500, 503, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (504, N'Import Tranfer Status', N'导入转正信息', N'Task/ImportTranferStatus.aspx', 500, 504, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (505, N'Import CFI', N'导入库存金额', N'Task/ImportCFI.aspx', 500, 505, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (506, N'New Pre-Contract', N'新增预合同', N'Task/EditPreContractInfo.aspx?id=0&ismain=1', 500, 506, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (507, N'Database Snapshot', N'数据库快照', N'Administration/DatabaseSnapshot.aspx', 500, 507, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (600, N'Administrator Menu', N'管理员菜单', NULL, 0, 600, 1, N'', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (601, N'Province Management', N'省份管理', N'Administration/ProvinceManagement.aspx', 600, 601, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (602, N'CAT Management', N'CAT管理', N'Administration/CAT.aspx', 600, 602, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (603, N'BG Management', N'BG管理', N'Administration/BGManagement.aspx', 600, 603, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (604, N'PU Management', N'PU管理', N'Administration/BDManagement.aspx', 600, 604, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (605, N'ExchangeRate Management', N'汇率管理', N'Administration/RateManagemet.aspx', 600, 605, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (606, N'Close Date Management', N'关帐日期管理', N'Administration/CloseDate.aspx', 600, 606, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (607, N'Report Month Management', N'报表月份管理', N'Administration/ReportMonth.aspx', 600, 607, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (608, N'The amount of key projects', N'关键项目金额', N'Administration/SearchAmount.aspx', 600, 608, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (609, N'Report Deadline', N'报表截止日期', N'Administration/DeadlineManagement.aspx', 600, 609, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (610, N'Help Files Management', N'帮助文件管理', N'Task/Help.aspx', 600, 610, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (611, N'User Management', N'人员管理', N'Administration/UserManagement.aspx', 600, 611, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (612, N'Logs Management', N'日志查询', N'Administration/LogViewer.aspx', 600, 612, 1, N'main', NULL)
INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (613, N'Dic Item Management', N'数据字典管理', N'Administration/DicItemManagement.aspx', 600, 613, 1, N'main', NULL)

INSERT [dbo].[MenuConfig] ([MenuID], [MenuTitle], [MenuTitle_CN], [MenuURL], [ParentMenuID], [MenuSequenceID], [IsEnabled], [Target], [MenuGroup]) VALUES (700, N'Data Maintenance', N'数据维护中', NULL, 0, 700, 1, N'', NULL)
SET IDENTITY_INSERT [dbo].[MenuConfig] OFF